UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9NlG0ejnTtN4m71z2W9ZpGFshOt9M3nJFI8IlWhhpU='
WHERE
key_id = '282549b9dae43656a30c9898942abccb75e83d478bf8e5bfba9dc268767a2c2f'
AND (
token = 'x9NlG0ejnTtN4m71z2W9ZpGFshOt9M3nJFI8IlWhhpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)