UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E6PmxxGGVEKgY98UadRn5mqcTAuMsg5pFe19Vd1s3I4='
WHERE
key_id = '697335199ad517928747a6799d6e37dcaca786dcb0535cd7b85c811b5a53ecff'
AND (
token = 'E6PmxxGGVEKgY98UadRn5mqcTAuMsg5pFe19Vd1s3I4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)