UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gz+5nX6uYP6wxhEjTsDONcH4lUiLe9RHBnnUtN9EkmY='
WHERE
key_id = '495ff6aff098f815f32bcadb32b40991901c1484c7a4aae8920f42f37ee5258d'
AND (
token = 'gz+5nX6uYP6wxhEjTsDONcH4lUiLe9RHBnnUtN9EkmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)