UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '58Qf9KWaE/LIzSQhxUSR0fGH/3WkqPstc7RKe9eOGCI='
WHERE
key_id = '4023ec867b596bc10e683ef1296c9d7f7c85a96d3837491e94af4efb96a69eb6'
AND (
token = '58Qf9KWaE/LIzSQhxUSR0fGH/3WkqPstc7RKe9eOGCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)