UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uCau/KofCgQOCgpUuV7rsMGg63fqyNptYduIPkx73VU='
WHERE
key_id = 'fd78f9cddd479e1eda186e329caebfb3d0acde6c1e000f11367c2a7650745177'
AND (
token = 'uCau/KofCgQOCgpUuV7rsMGg63fqyNptYduIPkx73VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)