UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNKKvD7LQnUv0EoaPvXjaQcfC5SymApHGHtJH2nEWMk='
WHERE
key_id = 'a43d55ca42a4e76ab0649066e4e0156be5d27d9730879010a38ab96108a3e298'
AND (
token = 'HNKKvD7LQnUv0EoaPvXjaQcfC5SymApHGHtJH2nEWMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)