UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzBV8mOiDcbzG4v9x73rTxd5tAkEB20BLqmIk04Tmyk='
WHERE
key_id = '782c86acae91cad51b6193527196fe8e7f479aa7061ebf932f565e4837e56551'
AND (
token = 'tzBV8mOiDcbzG4v9x73rTxd5tAkEB20BLqmIk04Tmyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)