UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TLkwohUc8HchXuXYxVicym2p2dcNg2+uWJK4MsEcZq4='
WHERE
key_id = 'bc8670daf05e28750f74f7a579f820935b7ba42ee0195c40e39670f2af12c5a3'
AND (
token = 'TLkwohUc8HchXuXYxVicym2p2dcNg2+uWJK4MsEcZq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)