UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xg9nQW+p6Zq5DBnPsLex9zwep0RFXJbAKlsvyvBbo1w='
WHERE
key_id = '4bf79cba2fa12b02507cf3787ad77108659301782392909134aca33007efcb69'
AND (
token = 'xg9nQW+p6Zq5DBnPsLex9zwep0RFXJbAKlsvyvBbo1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)