UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cP6K60veCa+TSHpa0deKiUqXJNOumYpi7K/5HRcLRRs='
WHERE
key_id = '12cc4fd29538d9deed88194f4a2976f322e5a02dedb165300f7a6578a5ff184a'
AND (
token = 'cP6K60veCa+TSHpa0deKiUqXJNOumYpi7K/5HRcLRRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)