UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3RiJb+C8SJ3jEHTnmiASgySq5clwLKEyZyMLA4qv/tA='
WHERE
key_id = '0fd306ecb226b463ba3998d625fdc135fce518006446a5193544fd92f9a91422'
AND (
token = '3RiJb+C8SJ3jEHTnmiASgySq5clwLKEyZyMLA4qv/tA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)