UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hnF9k/b5vSdhRs84f2Ha7kfcNzIPMDds7XH6B6noTyw='
WHERE
key_id = 'c56d7566d9572764c55195f55c37d4cd9293e5128099deb35069645513d5bb3b'
AND (
token = 'hnF9k/b5vSdhRs84f2Ha7kfcNzIPMDds7XH6B6noTyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)