UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TMrhPZ9APvfn/tmiWlTat/ZohT4EJQ1H1n7W5+wWAes='
WHERE
key_id = '6305eed9ad44faa8c6103aff3451f2671e746d843baef4c86bbcd73961b2b939'
AND (
token = 'TMrhPZ9APvfn/tmiWlTat/ZohT4EJQ1H1n7W5+wWAes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)