UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yb8zEDey9QDj4Dvaq3AF5kfyRm8Dh10jDbmEwScui6o='
WHERE
key_id = 'b9f7bc065a74f7e31fb11376c9832e9e0640a4850c5ca64c7055138d2b28548a'
AND (
token = 'Yb8zEDey9QDj4Dvaq3AF5kfyRm8Dh10jDbmEwScui6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)