UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wh7WGlKsSSLi8M/qE9ZxNIhbVUHoAVlv4ZiK8FjwjCw='
WHERE
key_id = '380f117a72f607669176a21b574faf38dedebe022805084673cb3a00b3bd4043'
AND (
token = 'wh7WGlKsSSLi8M/qE9ZxNIhbVUHoAVlv4ZiK8FjwjCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)