UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PMc1wwP0FqXKbBAkkTOQYVo38a5cDKX8lL0fjpIy4Yg='
WHERE
key_id = 'f13516327b019223a6751e0adb84e7d92437146cd8d67b6d6636adb996549f92'
AND (
token = 'PMc1wwP0FqXKbBAkkTOQYVo38a5cDKX8lL0fjpIy4Yg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)