UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's7v9V/aUUSR7CVGuE70tA+TffwPO/1WYKpQ99fJafVc='
WHERE
key_id = 'ca42afb8c30a71c05eb4d7947411189b4a747b1dc66f8bd99796e512c43bc263'
AND (
token = 's7v9V/aUUSR7CVGuE70tA+TffwPO/1WYKpQ99fJafVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)