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