UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QE1c7l6IFlLlYXA3DlWIDKIxy8GIw98YwdM3KwLbno='
WHERE
key_id = 'd245f37dcbff4d23a0228a30bb782d849f0c0ef00635920fe03787fb09cdeb63'
AND (
token = '0QE1c7l6IFlLlYXA3DlWIDKIxy8GIw98YwdM3KwLbno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)