UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gOIQ5D/XIVa95IzA44KZLTMqfOzyUprsnPorldUPsh8='
WHERE
key_id = '12ad42cde5966f646aa96c6ab92da8164a87dcc6d43b94d9471b5ed08b24e9ac'
AND (
token = 'gOIQ5D/XIVa95IzA44KZLTMqfOzyUprsnPorldUPsh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)