UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cVfudtbwjBAsRzdHx6dOjbdTtXdIV2nn2cg4DuU/Ymw='
WHERE
key_id = 'ca07a0c1e329a7c8d2561fe6174118fb35d7d5e677fcb26c4fedcf6d2cc01e8d'
AND (
token = 'cVfudtbwjBAsRzdHx6dOjbdTtXdIV2nn2cg4DuU/Ymw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)