UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9V3l8CiVWzn5dZ9WVVmbEEkn/MEWrjMUKap2SvmUg78='
WHERE
key_id = '6578681233119680af2924ec10edf27ebdb0087bff03712a24eaa55052027a74'
AND (
token = '9V3l8CiVWzn5dZ9WVVmbEEkn/MEWrjMUKap2SvmUg78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)