UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5P3nCiZTOs+64ulcQoQ99c8LYl8pYlhxdI/CpeX6r4='
WHERE
key_id = '96697f27abd8c029c0ce8766e93789911b41ca2a79fe3903b5d446ed4ac02efc'
AND (
token = 'z5P3nCiZTOs+64ulcQoQ99c8LYl8pYlhxdI/CpeX6r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)