UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XaVuM2h4nFWX733pjrV3xcrV64aWS8l/GWqxWM/GxQ='
WHERE
key_id = 'f94785349bc889843e4626ad86cd88f4ffa1878cfa965c591d78797f2f4d7c34'
AND (
token = '/XaVuM2h4nFWX733pjrV3xcrV64aWS8l/GWqxWM/GxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)