UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXDmDfTrtOW+uyTTBha1A0k+GJb8kv1FHmz+50qfbqQ='
WHERE
key_id = 'a30a1d87b942d46bda5c62c493c8b7c46782d8e9318a6a04c1a762b7e059b116'
AND (
token = 'hXDmDfTrtOW+uyTTBha1A0k+GJb8kv1FHmz+50qfbqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)