UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dhPJtbUehgzD6dJCST3mUHOEaDhEevycVomCZiO/ZDw='
WHERE
key_id = 'f9fc212d3cf8b62cb90209f1d5a175079027d11ecc962df63d28cc072bc35cac'
AND (
token = 'dhPJtbUehgzD6dJCST3mUHOEaDhEevycVomCZiO/ZDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)