UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mFhWJlT+PlpYF8R6LH+d4E4SBhWCpe2UNkZa+MeJesA='
WHERE
key_id = 'ac44d82c0f07e2a8728d0fdcc86c1aa620da8d9d4f6a5fda9f52dfe9947caad6'
AND (
token = 'mFhWJlT+PlpYF8R6LH+d4E4SBhWCpe2UNkZa+MeJesA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)