UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqW3SedjNuCJ13GQJ36/gS97+dx6LdH/nNcyEInl/q0='
WHERE
key_id = 'e4f03ccfd831a9f194e968c67ece0c701daa32b9480f22b9691c233af884c5c3'
AND (
token = 'pqW3SedjNuCJ13GQJ36/gS97+dx6LdH/nNcyEInl/q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)