UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SC6A7HefAtgzZr2MBB9jR2haJZg1KbcroJtwCIazY+M='
WHERE
key_id = '30393eb3167f9df351d46283a82564be154045cc983490c2d02e920ee90cc831'
AND (
token = 'SC6A7HefAtgzZr2MBB9jR2haJZg1KbcroJtwCIazY+M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)