UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WMv9+ZHQicLcaM7Cf2ZFsD/2+hkeqJQpWQOtbACRR0='
WHERE
key_id = 'c7dea9200cd63b147e9b2dea0fd10824ef17f4b1e09e2ece3dc83a44ffa4ad0f'
AND (
token = '0WMv9+ZHQicLcaM7Cf2ZFsD/2+hkeqJQpWQOtbACRR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)