UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ktT8SK1XYSslW8pxBbhz2Vfxe/bEEFnUEJwbdL/uv0='
WHERE
key_id = '92845b5867fc162f12824703b97cc285331e825eaaa448c07f6d61ec99793da9'
AND (
token = '7ktT8SK1XYSslW8pxBbhz2Vfxe/bEEFnUEJwbdL/uv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)