UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nRB+1gTkrJj4T5iUZ66dWxfYB1/PMuyhEHs77D1HQRU='
WHERE
key_id = 'e458a8bbc076c80eb2a620f22cd13985c1342f9a93a14226e04e844671b38874'
AND (
token = 'nRB+1gTkrJj4T5iUZ66dWxfYB1/PMuyhEHs77D1HQRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)