UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haXMH85v2Chujc/6Ik1YvpnjiRhMvSmxFz9EjPCZsE4='
WHERE
key_id = '5bec967859d938a5ca336f88626b474f91a90678395bcb8618a3e613adc09644'
AND (
token = 'haXMH85v2Chujc/6Ik1YvpnjiRhMvSmxFz9EjPCZsE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)