UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZyuHqUlv2WQHJi572v+SefWp5BHwKYCoEiuQfNbB0I='
WHERE
key_id = '7a4561a76fad21084af6e7460812457edf0e4ccd7101b908821a0304fd680f04'
AND (
token = 'gZyuHqUlv2WQHJi572v+SefWp5BHwKYCoEiuQfNbB0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)