UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsQB0RHUIm3MU81C2B9sHb1B34Cj7I9KcN1e7aHVZsI='
WHERE
key_id = '65a71272c3376ca78e70ca8b56ea114f939b20a9802b9da039ab4bf3c6452498'
AND (
token = 'hsQB0RHUIm3MU81C2B9sHb1B34Cj7I9KcN1e7aHVZsI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)