UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jpZA2p1jjgmC5MUQcTkJWNIK6KUIxdf8QuOmrnp08c='
WHERE
key_id = '20d843fa76f7b32a076657eb2291b9f29749f0cc14aeb97fe8f90430ebaf7f0b'
AND (
token = '6jpZA2p1jjgmC5MUQcTkJWNIK6KUIxdf8QuOmrnp08c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)