UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oZcSBuc8kf0gDy+FFU+hk9+WyNZIFUf8GOPF5Rih0Q='
WHERE
key_id = 'f9cf09e2fddd508ee3ad46545c18f35ec5c7d2550910ab778c3fb59fec3f9067'
AND (
token = '9oZcSBuc8kf0gDy+FFU+hk9+WyNZIFUf8GOPF5Rih0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)