UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RhKpf3XJuOWk+ArPd/C2r4CeG19TIxh+k0dk5BjWaug='
WHERE
key_id = 'b6dd342f84b2e5b2a83c450d1f9e5b96136e5504f7b62a32ec7eb4230bf2b588'
AND (
token = 'RhKpf3XJuOWk+ArPd/C2r4CeG19TIxh+k0dk5BjWaug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)