UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnOtlvMoXEEkGAVfOjUeTEHePdUzUMSCIlzoGuO7aj4='
WHERE
key_id = '667782dd68ccb9751378f14dd336e5a1c4d63815685837f907a8e5542d7bab2b'
AND (
token = 'YnOtlvMoXEEkGAVfOjUeTEHePdUzUMSCIlzoGuO7aj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)