UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkyKXYxT0hOxjMFGQXZIGUjgEYq0dyO5gbY4Z+iJRGI='
WHERE
key_id = '784674d0d5913ba816432504bbbf972a364a7f9bf1e06d49c74ec5367f699121'
AND (
token = 'pkyKXYxT0hOxjMFGQXZIGUjgEYq0dyO5gbY4Z+iJRGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)