UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9yrDzOlvy/wGhDwFjPkuB2bl3VY25SgIRMGoH5PLBw='
WHERE
key_id = '1577f42892ef0a6b1ea70bb85423e74ecd5ac8e1fe3339c5192a321d19e1178f'
AND (
token = 'W9yrDzOlvy/wGhDwFjPkuB2bl3VY25SgIRMGoH5PLBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)