UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q8iR+NYvA9TPa1Mg/tYoDqa0pux93z+REMQU9XJYiRk='
WHERE
key_id = '7e6a3e4ca9ca8576b1dc99d10adb53ac84e5dde7c370f2a2b1371efbafc18095'
AND (
token = 'q8iR+NYvA9TPa1Mg/tYoDqa0pux93z+REMQU9XJYiRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)