UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5C+4DEAUzSrm1bkkW9/e8MqYdNs14NLlHJI8Ci8a4bg='
WHERE
key_id = 'c6859531263191095d704e69162f1e621f518b423f83dc61289abcc44fb32cc9'
AND (
token = '5C+4DEAUzSrm1bkkW9/e8MqYdNs14NLlHJI8Ci8a4bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)