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